package com.fan.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.fan.entity.Order;
import com.fan.entity.PayLog;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface PayLogDao extends BaseMapper<PayLog> {

    @Select("select p.pay_time,p.transaction_id,p.pay_type,o.order_no,o.course_title,o.teacher_name,o.gmt_create,m.id from t_pay_log p join t_order o on p.order_no=o.order_no join tb_member m on o.mobile=m.mobile where o.order_no=#{orderNo}")
    List<Order> payLogOrderNo(String id);
}